<template>
  <view>
    <view class="uni-header">
      <view class="uni-group">
        <view class="uni-title"></view>
        <view class="uni-sub-title"></view>
      </view>
      <view class="uni-group">
        <input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入搜索内容" />
        <button class="uni-button" type="default" size="mini" @click="search">搜索</button>
        <button class="uni-button" type="default" size="mini" @click="navigateTo('./add')">新增</button>
        <button class="uni-button" type="default" size="mini" :disabled="!selectedIndexs.length"
          @click="delTable">批量删除</button>
        <download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData"
          :type="exportExcel.type" :name="exportExcel.filename">
          <button class="uni-button" type="primary" size="mini">导出 Excel</button>
        </download-excel>
      </view>
    </view>
    <view class="uni-container">
      <unicloud-db ref="udb" :collection="collectionList" :where="where" page-data="replace" :orderby="orderby"
        :getcount="true" :page-size="options.pageSize" :page-current="options.pageCurrent"
        v-slot:default="{ data, pagination, loading, error, options }" :options="options" loadtime="manual"
        @load="onqueryload">
        <uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe type="selection"
          @selection-change="selectionChange">
          <uni-tr>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'coupon_id[0]_id')"
              v-if="isSuperAdmin">优惠券ID</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'coupon_id[0].name')">优惠券名称</uni-th>
            <uni-th align="center" search @filter-change="filterChange($event, 'user_id[0].id')"
              v-if="isSuperAdmin">用户ID</uni-th>
            <uni-th align="center" filter-type="search" @sort-change="filterChange($event, 'user_id')">用户名字</uni-th>
            <uni-th align="center" filter-type="select" :filter-data="options.filterData.status_localdata"
              @filter-change="filterChange($event, 'status')">使用状态</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'receive_date')"
              sortable @sort-change="sortChange($event, 'receive_date')">领取时间</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'use_date')" sortable
              @sort-change="sortChange($event, 'use_date')">使用时间</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'expire_date')" sortable
              @sort-change="sortChange($event, 'expire_date')">过期时间</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'merchant_id')"
              v-if="isSuperAdmin">商家ID</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'remark')" sortable
              @sort-change="sortChange($event, 'remark')">备注</uni-th>
            <uni-th align="center" v-if="isSuperAdmin">操作</uni-th>
            <uni-th align="center" v-else>操作</uni-th>
          </uni-tr>
          <uni-tr v-for="(item, index) in data" :key="index">
            <uni-td align="center" v-if="isSuperAdmin">{{ item.coupon_id[0]._id }}</uni-td>
            <uni-td align="center">{{ item.coupon_id[0].name }}</uni-td>
            <uni-td align="center" v-if="isSuperAdmin">{{ item.user_id[0]._id }}</uni-td>
            <uni-td align="center">{{ item.user_id[0].name || '未填写' }}</uni-td>
            <uni-td align="center">{{ options.status_valuetotext[item.status] }}</uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.receive_date"></uni-dateformat>
            </uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.use_date"></uni-dateformat>
            </uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.expire_date"></uni-dateformat>
            </uni-td>
            <uni-td align="center" v-if="isSuperAdmin">{{ item.merchant_id }}</uni-td>
            <uni-td align="center">{{ item.remark || "无" }}</uni-td>
            <uni-td align="center" v-if="isSuperAdmin">
              <view class="uni-group">
                <button @click="navigateTo('./edit?id=' + item._id, false)" class="uni-button" size="mini"
                  type="primary">修改/详情</button>
                <button @click="confirmDelete(item._id)" class="uni-button" size="mini" type="warn">删除</button>
              </view>
            </uni-td>
            <uni-td align="center" v-else>
              <view class="uni-group">
                <button @click="toggle" class="uni-button" size="mini" type="primary">添加备注</button>
              </view>
            </uni-td>
          </uni-tr>
        </uni-table>
        <view class="uni-pagination-box">
          <uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current" :total="pagination.count"
            @change="onPageChanged" />
        </view>
      </unicloud-db>
      <view>
        <!-- 普通弹窗 -->
        <uni-popup ref="popup" type="right">
          <!-- <uni-popup ref="popup" background-color="#fff" @change="change"> -->
          <view class="popup-content" :class="{ 'popup-height': type === 'left' || type === 'right' }"><text
              class="text">popup 内容</text></view>
        </uni-popup>
      </view>
    </view>
  </view>
</template>

<script>
import { enumConverter, filterToWhere } from '@/js_sdk/validator/coupon-usage.js';

const db = uniCloud.database()
// 表查询配置
const dbOrderBy = '' // 排序字段
const dbSearchFields = [] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
// 分页配置
const pageSize = 20
const pageCurrent = 1

const orderByMapping = {
  "ascending": "asc",
  "descending": "desc"
}

export default {
  data() {
    return {
      // collectionList: "coupon-usage",
      collectionList: [
        db.collection('coupon-usage')
          .field('coupon_id,user_id,status,receive_date,use_date,expire_date,merchant_id,remark')
          .getTemp(),
        db.collection('coupons')
          .field('_id,name')
          .getTemp(),
        db.collection('uni-id-users')
          .field('_id,name')
          .getTemp()
      ],
      query: '',
      where: '',
      orderby: dbOrderBy,
      orderByFieldName: "",
      selectedIndexs: [],
      options: {
        pageSize,
        pageCurrent,
        filterData: {
          "status_localdata": [
            {
              "value": 0,
              "text": "已领取"
            },
            {
              "value": 1,
              "text": "已核销"
            },
            {
              "value": 2,
              "text": "已过期"
            }
          ]
        },
        ...enumConverter
      },
      imageStyles: {
        width: 64,
        height: 64
      },
      exportExcel: {
        "filename": "coupon-usage.xls",
        "type": "xls",
        "fields": {
          "优惠券ID": "coupon_id",
          "用户ID": "user_id",
          "使用状态": "status",
          "领取时间": "receive_date",
          "使用时间": "use_date",
          "过期时间": "expire_date",
          "商家ID": "merchant_id",
          "备注": "remark"
        }
      },
      exportExcelData: []
    }
  },
  onLoad() {
    this._filter = {}
  },
  onReady() {
    this.$refs.udb.loadData()
  },
  computed: {
    isSuperAdmin() {
      return this.$hasRole("admin")
    }
  },
  methods: {
    toggle() {
      // this.type = type
      // open 方法传入参数 等同在 uni-popup 组件上绑定 type属性
      this.$refs.popup.open('right')
    },
    onqueryload(data) {
      this.exportExcelData = data
    },
    getWhere() {
      const query = this.query.trim()
      if (!query) {
        return ''
      }
      const queryRe = new RegExp(query, 'i')
      return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
    },
    search() {
      const newWhere = this.getWhere()
      this.where = newWhere
      this.$nextTick(() => {
        this.loadData()
      })
    },
    loadData(clear = true) {
      this.$refs.udb.loadData({
        clear
      })
    },
    onPageChanged(e) {
      this.selectedIndexs.length = 0
      this.$refs.table.clearSelection()
      this.$refs.udb.loadData({
        current: e.current
      })
    },
    navigateTo(url, clear) {
      // clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
      uni.navigateTo({
        url,
        events: {
          refreshData: () => {
            this.loadData(clear)
          }
        }
      })
    },
    // 多选处理
    selectedItems() {
      var dataList = this.$refs.udb.dataList
      return this.selectedIndexs.map(i => dataList[i]._id)
    },
    // 批量删除
    delTable() {
      this.$refs.udb.remove(this.selectedItems(), {
        success: (res) => {
          this.$refs.table.clearSelection()
        }
      })
    },
    // 多选
    selectionChange(e) {
      this.selectedIndexs = e.detail.index
    },
    confirmDelete(id) {
      this.$refs.udb.remove(id, {
        success: (res) => {
          this.$refs.table.clearSelection()
        }
      })
    },
    sortChange(e, name) {
      this.orderByFieldName = name;
      if (e.order) {
        this.orderby = name + ' ' + orderByMapping[e.order]
      } else {
        this.orderby = ''
      }
      this.$refs.table.clearSelection()
      this.$nextTick(() => {
        this.$refs.udb.loadData()
      })
    },
    filterChange(e, name) {
      this._filter[name] = {
        type: e.filterType,
        value: e.filter
      }
      let newWhere = filterToWhere(this._filter, db.command)
      if (Object.keys(newWhere).length) {
        this.where = newWhere
      } else {
        this.where = ''
      }
      this.$nextTick(() => {
        this.$refs.udb.loadData()
      })
    }
  }
}
</script>

<style></style>
